ARR Forecasting & Modeling

Section 01

01

Partner Revenue Classification

📥

Partner-Sourced

Opportunities originated by a partner through active prospecting, referral, or co-sell motion. Partner holds sourcing credit regardless of close involvement.

🤝

Partner-Influenced

Opportunities where a partner accelerated, qualified, or technically validated a deal that was vendor-sourced. Influence weight tracked separately from sourced ARR.

🔄

Resale / Transacted

Revenue transacted through a reseller or distributor — tracked at the point-of-sale and mapped back to partner tier, region, and deal type.

📈

Expansion ARR

Renewal and upsell revenue on partner-attached accounts. Tracked by partner role in the expansion motion — renewal assist, QBR involvement, or upsell lead.

CRM Required Partner Attribution Sourced vs. Influenced

Section 02

02

Partner Pipeline Structure

Qualified Pipeline

Opportunities that have met minimum qualification criteria — BANT, mutual commit, or defined entry stage — and are tracked as active in CRM with a partner association.

Weighted Pipeline

Qualified pipeline adjusted by stage-level close probability. Weighted figures are used for rollup forecasting and board reporting. Partner-sourced weighted pipeline tracked separately.

Coverage Ratio

Total pipeline divided by ARR target. Minimum 3:1 coverage for commit-level confidence; 4–5:1 for best case. Tracked by partner tier, region, and segment.

Stage Velocity

Average number of days an opportunity spends in each pipeline stage. Partner-attached deals benchmarked against direct motion to identify acceleration or friction patterns.

Pipeline at Risk

Opportunities that have stalled (no activity in 14–21 days), aged past expected close date, or lost partner engagement signals — flagged for intervention.

Framework Note

Pipeline coverage targets should be set by partner type, not globally. Reseller-sourced deals typically carry different velocity profiles than alliance or GSI-influenced opportunities — conflating them masks real forecast risk.

Section 03

03

Forecast Modeling

Core ARR Forecast Formula

Partner ARR Forecast =
  (Qualified Pipeline × Conversion Rate)
  + Renewal ARR at Risk Adjusted
  + Expansion Pipeline (Weighted)

Conversion Rate = Closed Won ÷ Qualified Entered (trailing 90d)

📊

Commit Forecast

High-confidence opportunities with clear close signals, mutual commitment, and partner confirmation. Rep-submitted, manager-reviewed. Used for board-level reporting.

🎯

Best Case Forecast

All commit-level deals plus additional qualified opportunities with meaningful close potential. Reflects upside if momentum holds across all active partner motions.

📉

Downside Scenario

Conservative view that discounts pipeline at risk, accounts with low partner engagement, and deals dependent on single-threaded champion relationships.

🔁

Rolling 90-Day Model

Forecast model updated on a rolling 90-day basis using trailing conversion rates, historical seasonality, and partner program tier adjustments.

Section 04

04

ARR Attribution Model

First-Touch Attribution

100% of ARR credit assigned to the partner who originated the opportunity. Used for sourced ARR reporting and partner compensation calculations.

Multi-Touch Attribution

ARR credit distributed across all partners involved in the deal lifecycle — sourcing, technical validation, proposal support, and close assist. Weighted by role and stage of involvement.

Influenced ARR (Separate)

Tracks deal velocity improvement, win rate lift, and deal size increase attributable to partner involvement. Reported alongside but not included in sourced ARR totals.

Renewal Attribution

Partner credit on renewals assigned based on documented engagement during the renewal cycle — QBR participation, escalation support, or expansion proposal involvement.

Worked Example

A $100K ARR deal sourced by Partner A, technically validated by Partner B, and closed with reseller Partner C: Under first-touch, Partner A receives 100% sourcing credit. Under multi-touch, a weighted split applies — e.g., 60% / 25% / 15% based on defined role weights. Influenced ARR is tracked separately for Partners B and C regardless of attribution model used.

Section 05

05

Partner Capacity & Seller Metrics

Effective Sellers Formula

Effective Sellers = Active Sellers × Productivity Factor

Productivity Factor = Avg Pipeline per Rep ÷ Target Pipeline per Rep

Partner Pipeline Production =
Effective Sellers × Avg Deal Size × Conversion Rate × Frequency

👥

Active Seller Count

Partners with at least one qualified opportunity registered in the trailing 90 days. Active seller counts drive capacity modeling and territory planning assumptions.

⚡

Productivity Index

Ratio of actual pipeline generated per partner seller vs. the established benchmark for their tier and segment. Used to identify underperforming partners before they become forecast gaps.

🗓️

Booth / Event Model

Forecast uplift from partner-driven events modeled using historical conversion rates. Event pipeline tracked separately with a 90-day post-event attribution window applied.

Section 06

06

Core ARR Metrics

Partner-Sourced ARR %

Partner-sourced closed ARR divided by total new ARR for the period. Primary measure of channel contribution to revenue. Benchmarked quarterly and trended YoY.

Win Rate by Partner Type

Close rate segmented by partner tier, type (reseller / alliance / GSI), and deal size band. Identifies where partner involvement creates the most competitive lift.

Average Deal Size

Average ARR per closed deal, segmented by partner-attached vs. direct. Partner-attached deals often show size lift — tracking this supports program investment justification.

Net Revenue Retention (Partner)

ARR retained and expanded on partner-attached accounts, expressed as a percentage of beginning ARR. Tracks partner impact on customer lifetime value.

Forecast Accuracy

Actual closed ARR vs. submitted forecast at 30-, 60-, and 90-day intervals. Tracked by channel segment to surface systematic forecast inflation or sandbagging patterns.

Pipeline to ARR Ratio

Total qualified partner pipeline divided by ARR target for the period. Minimum thresholds defined by tier; tracked weekly to catch coverage gaps before quarter-end.

Section 07

07

Forecast Confidence Scoring

🟢

High Confidence

Active partner engagement, documented mutual close plan, executive alignment on both sides, legal in progress. Score: 80–100. Included in commit forecast.

🟡

Medium Confidence

Partner engaged but close plan not formalized, or timeline has shifted once. Score: 50–79. Included in best case. Requires bi-weekly check-in cadence.

🔴

Low Confidence

Stalled activity, single-threaded, or partner disengaged. Score: below 50. Excluded from forecast; flagged for recovery action or pipeline scrub.

⚪

Unscored / New

Newly registered or recently qualified — not yet assessed. Must be scored within 5 business days of qualification. Excluded from all forecast tiers until scored.

Scoring Application

Confidence scores are assigned by channel managers at weekly pipeline reviews, not automatically by CRM stage. Stage ≠ confidence. A deal can be at late-stage with low confidence if partner engagement has dropped — and this distinction is what separates accurate forecasting from wishful pipeline.

Section 08

08

Executive Dashboard Structure

Channel Revenue Summary

Partner-sourced ARR vs. target, YoY growth, and channel mix % — updated weekly. Includes prior quarter actuals for baseline comparison and executive commentary section.

Pipeline Health View

Total qualified pipeline, coverage ratio by segment, stage distribution, and confidence tier breakdown. Designed for VP/CRO weekly review — single-screen layout, no drill-down required.

Forecast Rollup

Commit, best case, and downside ARR by region and partner tier. Includes gap-to-target, forecast accuracy trend, and prior-period variance explanation.

Partner Contribution View

Top 10 partners by pipeline and closed ARR, deal velocity comparison vs. baseline, and partner-tier performance vs. program expectations.

At-Risk & Action Items

Deals in pipeline scrub, partners with declining engagement metrics, renewals at risk by partner-attached account, and recovery actions with owners and due dates.

Built for CRO VP Channel RevOps Channel Managers Finance

Section 09

09

Data Architecture Requirements

🗄️

CRM Object Structure

Opportunity records must carry partner association fields, sourcing type, influence flags, and attribution weight. Partner Account object linked at the relationship level, not just the deal level.

🔗

PRM Integration

Deal registration data from PRM (Alliances, Impartner, Salesforce PRM) must sync to CRM with source-of-truth logic defined. Conflicts resolved by CRM ownership rules, not manual override.

📋

Required Opportunity Fields

Partner name, partner type, sourcing classification, influence weight, registration date, last partner activity date, and close confidence score. All required for forecast inclusion.

🔍

Reporting Layer

Forecast and pipeline reports built on validated CRM data — not spreadsheet exports. Reporting layer (Salesforce dashboards, Tableau, or Clari) connected to live opportunity data with defined refresh cadence.

Data Quality Note

Forecast accuracy is only as good as CRM hygiene. This framework includes field completion rate tracking as a leading indicator of data quality — if required fields aren't populated, deals are excluded from forecast rollup until remediated. This creates accountability at the rep level without requiring a separate audit process.

Section 10

10

Best Practices Summary

📌

Forecasting Principles

Use trailing 90-day conversion rates — not historical averages. Set coverage targets by partner type. Never include unscored pipeline in any forecast tier. Review weekly, not monthly.

📡

Reporting Discipline

Report sourced ARR and influenced ARR separately — always. Never blend them to make numbers look better. Executives need to trust the model before they'll act on it.

⚙️

Operations Hygiene

Run a formal pipeline scrub at least bi-weekly with channel managers. Stale deals inflate forecast and erode leadership confidence faster than missed numbers do.

Best applied by Head of Channel RevOps Leaders Channel Ops Managers Alliances Teams

ARR Forecasting& Modeling